1001 Secrets for Windows NT Registry
(Publisher: 29th Street Press)
Author(s): Tim Daniels
ISBN: 1882419685
Publication Date: 12/01/97

Previous Table of Contents Next


Microsoft Excel 8.0/97

The following registry keys control the various options that are available within Microsoft Excel 97. Note that to change any of these options, you must exit Excel, change the registry key, then restart Excel.

IV-18 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: DefaultPath
Data Type: REG_SZ
Value: D:\My Documents

This value sets the default storage location and search path for documents that you create or use in Microsoft Excel 97. This value overrides the path set in the HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\Personal registry key.

IV-19 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Shared Tools\Outlook\Journaling\ Microsoft Excel
Value Name: Enabled
Data Type: REG_DWORD
Value: 0x1

This value controls the Journaling feature in Microsoft Outlook and tracks when and how long you work with any Microsoft Excel Documents.

IV-20 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: Maximized
Data Type: REG_DWORD
Value: 0x3

This value controls how Excel displays its window and workbook window when starting up. Note that Excel overwrites this value with its current settings when it exits. You have the following options for this value:

3 Excel and Workbook window maximized
2 Workbook window maximized
1 Excel maximized, Workbook window not maximized
0 Nothing maximized

IV-21 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: Pos
Data Type: REG_SZ
Value: left, top, right, bottom

This value tells Excel how big to make its window and the position of the Top, Left, Right and Bottom corners of its window. An example of a valid value is 66,66,600,411

IV-22 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: Default Chart
Data Type: REG_SZ
Value: <type:charttype, subtype>

This value sets Excel’s default chart, which is a two-dimensional column chart. The type can be Standard, Built-in, or User-defined; for the charttype variable, select one of the charts listed in the Chart Type menu on the Chart/Chart Type dialog box. Similarly, for the subtype variable, choose one of the Chart sub-types found in the same dialog box. The default value is Standard:1,1. Note that user-defined chart formats are stored in a file called Xlusrgal.xls, which is located in the Program Files\Microsoft Office\Office folder.

IV-23 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: DefSheets
Data Type: REG_DWORD
Value: 0x3

This value tells Excel how many worksheets to create in a new workbook. If you set this to 1, a new workbook contains only one worksheet.

IV-24 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: MoveEnterDir
Data Type: REG_DWORD
Value: 0x1


Previous Table of Contents Next